Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 966400 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 3158 |
| Duplicate rows (%) | 0.3% |
| Total size in memory | 667.1 MiB |
| Average record size in memory | 723.8 B |
Variable types
| Numeric | 10 |
|---|---|
| DateTime | 2 |
| Categorical | 8 |
| Text | 4 |
| Dataset has 3158 (0.3%) duplicate rows | Duplicates |
CATEGORY is highly overall correlated with SUBCATEGORY | High correlation |
DAY_OF_YEAR is highly overall correlated with MONTH and 3 other fields | High correlation |
MNTH_CODE is highly overall correlated with QUARTER and 1 other fields | High correlation |
MONTH is highly overall correlated with DAY_OF_YEAR and 3 other fields | High correlation |
OC_CODE is highly overall correlated with DAY_OF_YEAR and 3 other fields | High correlation |
QUARTER is highly overall correlated with DAY_OF_YEAR and 4 other fields | High correlation |
SALES_PTR_VALUE is highly overall correlated with SALES_VALUE and 1 other fields | High correlation |
SALES_VALUE is highly overall correlated with SALES_PTR_VALUE and 1 other fields | High correlation |
SALES_VOLUME is highly overall correlated with SALES_PTR_VALUE and 1 other fields | High correlation |
SUBCATEGORY is highly overall correlated with CATEGORY | High correlation |
YEAR is highly overall correlated with DAY_OF_YEAR and 4 other fields | High correlation |
SALES_VALUE is highly skewed (γ1 = 33.86988697) | Skewed |
SALES_UNITS is highly skewed (γ1 = 57.47378806) | Skewed |
SALES_VOLUME is highly skewed (γ1 = 34.22440987) | Skewed |
SALES_PTR_VALUE is highly skewed (γ1 = 32.65774068) | Skewed |
DAY_OF_WEEK has 102473 (10.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-09-26 14:43:16.624555 |
|---|---|
| Analysis finished | 2024-09-26 14:44:14.558505 |
| Duration | 57.93 seconds |
| Software version | ydata-profiling vv4.10.0 |
| Download configuration | config.json |
MNTH_CODE
Real number (ℝ)
HIGH CORRELATION
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 202372.88 |
| Minimum | 202309 |
|---|---|
| Maximum | 202408 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 202309 |
|---|---|
| 5-th percentile | 202309 |
| Q1 | 202312 |
| median | 202403 |
| Q3 | 202406 |
| 95-th percentile | 202408 |
| Maximum | 202408 |
| Range | 99 |
| Interquartile range (IQR) | 94 |
Descriptive statistics
| Standard deviation | 44.525843 |
|---|---|
| Coefficient of variation (CV) | 0.00022001883 |
| Kurtosis | -1.5218993 |
| Mean | 202372.88 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.68520023 |
| Sum | 1.9557315 × 1011 |
| Variance | 1982.5507 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 202406 | 102585 | |
| 202309 | 96453 | |
| 202312 | 89583 | |
| 202403 | 84599 | |
| 202407 | 83813 | |
| 202408 | 74960 | |
| 202404 | 74939 | |
| 202402 | 74173 | |
| 202311 | 73399 | |
| 202401 | 73094 | |
| Other values (2) | 138802 |
| Value | Count | Frequency (%) |
| 202309 | 96453 | |
| 202310 | 66211 | |
| 202311 | 73399 | |
| 202312 | 89583 | |
| 202401 | 73094 | |
| 202402 | 74173 | |
| 202403 | 84599 | |
| 202404 | 74939 | |
| 202405 | 72591 | |
| 202406 | 102585 |
| Value | Count | Frequency (%) |
| 202408 | 74960 | |
| 202407 | 83813 | |
| 202406 | 102585 | |
| 202405 | 72591 | |
| 202404 | 74939 | |
| 202403 | 84599 | |
| 202402 | 74173 | |
| 202401 | 73094 | |
| 202312 | 89583 | |
| 202311 | 73399 |
TRANS_DATE
Date
| Distinct | 303 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| Minimum | 2023-08-29 00:00:00 |
|---|---|
| Maximum | 2024-08-27 00:00:00 |
Histogram with fixed size bins (bins=50)
START_DATE
Date
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 MiB |
| Minimum | 2023-08-28 00:00:00 |
|---|---|
| Maximum | 2024-07-31 00:00:00 |
Histogram with fixed size bins (bins=12)
SALES_VALUE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 8242 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 446.41745 |
| Minimum | 2.86 |
|---|---|
| Maximum | 145728.12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 MiB |
Quantile statistics
| Minimum | 2.86 |
|---|---|
| 5-th percentile | 53.57 |
| Q1 | 140 |
| median | 192.24 |
| Q3 | 450 |
| 95-th percentile | 1537.89 |
| Maximum | 145728.12 |
| Range | 145725.26 |
| Interquartile range (IQR) | 310 |
Descriptive statistics
| Standard deviation | 1053.3556 |
|---|---|
| Coefficient of variation (CV) | 2.3595754 |
| Kurtosis | 2647.1191 |
| Mean | 446.41745 |
| Median Absolute Deviation (MAD) | 87.76 |
| Skewness | 33.869887 |
| Sum | 4.3141783 × 108 |
| Variance | 1109558.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 142.86 | 106972 | 11.1% |
| 53.57 | 42760 | 4.4% |
| 140 | 39597 | 4.1% |
| 138.57 | 30170 | 3.1% |
| 107.14 | 28309 | 2.9% |
| 137.14 | 24945 | 2.6% |
| 142.84 | 21903 | 2.3% |
| 280 | 12096 | 1.3% |
| 131.06 | 10428 | 1.1% |
| 163.64 | 10138 | 1.0% |
| Other values (8232) | 639082 |
| Value | Count | Frequency (%) |
| 2.86 | 2 | < 0.1% |
| 4.46 | 42 | < 0.1% |
| 7.81 | 1 | < 0.1% |
| 8.57 | 10 | < 0.1% |
| 8.65 | 1 | < 0.1% |
| 8.66 | 13 | < 0.1% |
| 8.75 | 16 | < 0.1% |
| 8.92 | 1 | < 0.1% |
| 8.93 | 254 | |
| 13.39 | 84 | < 0.1% |
| Value | Count | Frequency (%) |
| 145728.12 | 1 | |
| 144803.75 | 1 | |
| 118027.64 | 1 | |
| 117676.65 | 1 | |
| 114606.54 | 1 | |
| 112931 | 1 | |
| 104407.27 | 1 | |
| 103488 | 1 | |
| 96727.27 | 1 | |
| 95594.54 | 1 |
SALES_UNITS
Real number (ℝ)
SKEWED
| Distinct | 359 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.696476 |
| Minimum | 1 |
|---|---|
| Maximum | 10240 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 6 |
| Q3 | 16 |
| 95-th percentile | 32 |
| Maximum | 10240 |
| Range | 10239 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 40.761336 |
|---|---|
| Coefficient of variation (CV) | 3.210445 |
| Kurtosis | 7131.9482 |
| Mean | 12.696476 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 57.473788 |
| Sum | 12269874 |
| Variance | 1661.4865 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16 | 260404 | |
| 1 | 131257 | |
| 2 | 122969 | |
| 3 | 119386 | |
| 6 | 72771 | 7.5% |
| 12 | 71214 | 7.4% |
| 32 | 57991 | 6.0% |
| 4 | 34619 | 3.6% |
| 24 | 25479 | 2.6% |
| 8 | 17878 | 1.8% |
| Other values (349) | 52432 | 5.4% |
| Value | Count | Frequency (%) |
| 1 | 131257 | |
| 2 | 122969 | |
| 3 | 119386 | |
| 4 | 34619 | 3.6% |
| 5 | 5173 | 0.5% |
| 6 | 72771 | |
| 7 | 579 | 0.1% |
| 8 | 17878 | 1.8% |
| 9 | 601 | 0.1% |
| 10 | 2070 | 0.2% |
| Value | Count | Frequency (%) |
| 10240 | 1 | < 0.1% |
| 6000 | 1 | < 0.1% |
| 5120 | 2 | |
| 4800 | 1 | < 0.1% |
| 4388 | 1 | < 0.1% |
| 3840 | 1 | < 0.1% |
| 3600 | 3 | |
| 3500 | 1 | < 0.1% |
| 3360 | 1 | < 0.1% |
| 3200 | 1 | < 0.1% |
SALES_VOLUME
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 1581 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.00093144967 |
| Minimum | 1.1 × 10-5 |
|---|---|
| Maximum | 0.2755 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 MiB |
Quantile statistics
| Minimum | 1.1 × 10-5 |
|---|---|
| 5-th percentile | 0.000144 |
| Q1 | 0.000368 |
| median | 0.000448 |
| Q3 | 0.0009 |
| 95-th percentile | 0.00286 |
| Maximum | 0.2755 |
| Range | 0.275489 |
| Interquartile range (IQR) | 0.000532 |
Descriptive statistics
| Standard deviation | 0.0020629814 |
|---|---|
| Coefficient of variation (CV) | 2.2148071 |
| Kurtosis | 2628.5773 |
| Mean | 0.00093144967 |
| Median Absolute Deviation (MAD) | 0.000198 |
| Skewness | 34.22441 |
| Sum | 900.15296 |
| Variance | 4.2558922 × 10-6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.000384 | 67198 | 7.0% |
| 0.0004 | 63048 | 6.5% |
| 0.000416 | 44261 | 4.6% |
| 0.0005 | 32689 | 3.4% |
| 0.000144 | 32367 | 3.3% |
| 0.0003 | 25749 | 2.7% |
| 0.00075 | 24511 | 2.5% |
| 0.000368 | 22589 | 2.3% |
| 0.000272 | 21633 | 2.2% |
| 0.000132 | 20296 | 2.1% |
| Other values (1571) | 612059 |
| Value | Count | Frequency (%) |
| 1.1 × 10-5 | 6 | < 0.1% |
| 1.2 × 10-5 | 36 | < 0.1% |
| 1.7 × 10-5 | 17 | < 0.1% |
| 1.8 × 10-5 | 6 | < 0.1% |
| 2 × 10-5 | 7 | < 0.1% |
| 2.2 × 10-5 | 22 | < 0.1% |
| 2.3 × 10-5 | 33 | < 0.1% |
| 2.4 × 10-5 | 106 | |
| 2.5 × 10-5 | 47 | |
| 2.6 × 10-5 | 50 |
| Value | Count | Frequency (%) |
| 0.2755 | 1 | < 0.1% |
| 0.256 | 1 | < 0.1% |
| 0.2464 | 1 | < 0.1% |
| 0.242 | 1 | < 0.1% |
| 0.2375 | 1 | < 0.1% |
| 0.219 | 1 | < 0.1% |
| 0.21 | 1 | < 0.1% |
| 0.2097 | 1 | < 0.1% |
| 0.2095 | 1 | < 0.1% |
| 0.192 | 3 |
SALES_PTR_VALUE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 2024 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 457.81468 |
| Minimum | 1.7857143 |
|---|---|
| Maximum | 151800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 MiB |
Quantile statistics
| Minimum | 1.7857143 |
|---|---|
| 5-th percentile | 53.571429 |
| Q1 | 142.85714 |
| median | 198.18182 |
| Q3 | 450 |
| 95-th percentile | 1585.4545 |
| Maximum | 151800 |
| Range | 151798.21 |
| Interquartile range (IQR) | 307.14286 |
Descriptive statistics
| Standard deviation | 1101.7691 |
|---|---|
| Coefficient of variation (CV) | 2.4065832 |
| Kurtosis | 2447.2998 |
| Mean | 457.81468 |
| Median Absolute Deviation (MAD) | 91.038961 |
| Skewness | 32.657741 |
| Sum | 4.4243211 × 108 |
| Variance | 1213895.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 142.8571429 | 239443 | |
| 53.57142857 | 52969 | 5.5% |
| 285.7142857 | 50215 | 5.2% |
| 107.1428571 | 33816 | 3.5% |
| 163.6363636 | 10338 | 1.1% |
| 313.6363636 | 9855 | 1.0% |
| 336.3636364 | 9789 | 1.0% |
| 270 | 9751 | 1.0% |
| 104.5454545 | 9638 | 1.0% |
| 209.0909091 | 9229 | 1.0% |
| Other values (2014) | 531357 |
| Value | Count | Frequency (%) |
| 1.785714286 | 1 | < 0.1% |
| 4.464285714 | 42 | < 0.1% |
| 8.035714286 | 6 | < 0.1% |
| 8.928571429 | 290 | |
| 13.39285714 | 84 | < 0.1% |
| 16.07142857 | 5 | < 0.1% |
| 17.85714286 | 260 | |
| 22.32142857 | 15 | < 0.1% |
| 24.10714286 | 3 | < 0.1% |
| 26.78571429 | 90 | < 0.1% |
| Value | Count | Frequency (%) |
| 151800 | 1 | |
| 144659.0909 | 1 | |
| 120436.3636 | 1 | |
| 117559.0909 | 1 | |
| 116945.4545 | 1 | |
| 112818.1818 | 1 | |
| 107636.3636 | 1 | |
| 105600 | 1 | |
| 97545.45455 | 1 | |
| 97454.54545 | 2 |
OC_CODE
Real number (ℝ)
HIGH CORRELATION
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 202206.57 |
| Minimum | 202201 |
|---|---|
| Maximum | 202212 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 202201 |
|---|---|
| 5-th percentile | 202201 |
| Q1 | 202204 |
| median | 202207 |
| Q3 | 202209 |
| 95-th percentile | 202212 |
| Maximum | 202212 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.4045263 |
|---|---|
| Coefficient of variation (CV) | 1.6836873 × 10-5 |
| Kurtosis | -1.1578826 |
| Mean | 202206.57 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.0061898714 |
| Sum | 1.9541243 × 1011 |
| Variance | 11.590799 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 202206 | 102585 | |
| 202209 | 96453 | |
| 202212 | 89583 | |
| 202203 | 84599 | |
| 202207 | 83813 | |
| 202208 | 74960 | |
| 202204 | 74939 | |
| 202202 | 74173 | |
| 202211 | 73399 | |
| 202201 | 73094 | |
| Other values (2) | 138802 |
| Value | Count | Frequency (%) |
| 202201 | 73094 | |
| 202202 | 74173 | |
| 202203 | 84599 | |
| 202204 | 74939 | |
| 202205 | 72591 | |
| 202206 | 102585 | |
| 202207 | 83813 | |
| 202208 | 74960 | |
| 202209 | 96453 | |
| 202210 | 66211 |
| Value | Count | Frequency (%) |
| 202212 | 89583 | |
| 202211 | 73399 | |
| 202210 | 66211 | |
| 202209 | 96453 | |
| 202208 | 74960 | |
| 202207 | 83813 | |
| 202206 | 102585 | |
| 202205 | 72591 | |
| 202204 | 74939 | |
| 202203 | 84599 |
DISTRIBUTOR_CODE
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 58.1 MiB |
| DB0110 | |
|---|---|
| DB0209 | |
| DB0706 | |
| DB0652 | |
| DB0655 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 5798400 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DB0706 |
|---|---|
| 2nd row | DB0706 |
| 3rd row | DB0706 |
| 4th row | DB0652 |
| 5th row | DB0652 |
Common Values
| Value | Count | Frequency (%) |
| DB0110 | 278245 | |
| DB0209 | 217421 | |
| DB0706 | 194044 | |
| DB0652 | 142181 | |
| DB0655 | 134509 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| db0110 | 278245 | |
| db0209 | 217421 | |
| db0706 | 194044 | |
| db0652 | 142181 | |
| db0655 | 134509 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1656110 | |
| D | 966400 | |
| B | 966400 | |
| 1 | 556490 | 9.6% |
| 6 | 470734 | 8.1% |
| 5 | 411199 | 7.1% |
| 2 | 359602 | 6.2% |
| 9 | 217421 | 3.7% |
| 7 | 194044 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5798400 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1656110 | |
| D | 966400 | |
| B | 966400 | |
| 1 | 556490 | 9.6% |
| 6 | 470734 | 8.1% |
| 5 | 411199 | 7.1% |
| 2 | 359602 | 6.2% |
| 9 | 217421 | 3.7% |
| 7 | 194044 | 3.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5798400 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1656110 | |
| D | 966400 | |
| B | 966400 | |
| 1 | 556490 | 9.6% |
| 6 | 470734 | 8.1% |
| 5 | 411199 | 7.1% |
| 2 | 359602 | 6.2% |
| 9 | 217421 | 3.7% |
| 7 | 194044 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5798400 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1656110 | |
| D | 966400 | |
| B | 966400 | |
| 1 | 556490 | 9.6% |
| 6 | 470734 | 8.1% |
| 5 | 411199 | 7.1% |
| 2 | 359602 | 6.2% |
| 9 | 217421 | 3.7% |
| 7 | 194044 | 3.3% |
OUTLET_CODE
Text
| Distinct | 18833 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 59.5 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.5882212 |
| Min length | 7 |
Characters and Unicode
| Total characters | 7333257 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 382 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OL144111 |
|---|---|
| 2nd row | OL238706 |
| 3rd row | OL223076 |
| 4th row | OL175529 |
| 5th row | OL48851 |
| Value | Count | Frequency (%) |
| ol128896 | 1289 | 0.1% |
| ol191061 | 1277 | 0.1% |
| ol49938 | 1243 | 0.1% |
| ol143966 | 1223 | 0.1% |
| ol11104 | 1114 | 0.1% |
| ol223486 | 1089 | 0.1% |
| ol191033 | 1085 | 0.1% |
| ol32854 | 1080 | 0.1% |
| ol80887 | 1048 | 0.1% |
| ol159815 | 1035 | 0.1% |
| Other values (18823) | 954917 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 966400 | |
| L | 966400 | |
| 1 | 879608 | |
| 2 | 729852 | |
| 3 | 514930 | |
| 9 | 513662 | |
| 4 | 494825 | |
| 6 | 477333 | |
| 5 | 467004 | |
| 8 | 459480 | |
| Other values (2) | 863763 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7333257 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 966400 | |
| L | 966400 | |
| 1 | 879608 | |
| 2 | 729852 | |
| 3 | 514930 | |
| 9 | 513662 | |
| 4 | 494825 | |
| 6 | 477333 | |
| 5 | 467004 | |
| 8 | 459480 | |
| Other values (2) | 863763 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7333257 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 966400 | |
| L | 966400 | |
| 1 | 879608 | |
| 2 | 729852 | |
| 3 | 514930 | |
| 9 | 513662 | |
| 4 | 494825 | |
| 6 | 477333 | |
| 5 | 467004 | |
| 8 | 459480 | |
| Other values (2) | 863763 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7333257 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 966400 | |
| L | 966400 | |
| 1 | 879608 | |
| 2 | 729852 | |
| 3 | 514930 | |
| 9 | 513662 | |
| 4 | 494825 | |
| 6 | 477333 | |
| 5 | 467004 | |
| 8 | 459480 | |
| Other values (2) | 863763 |
CITY
Text
| Distinct | 1679 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.6 MiB |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 8.7443057 |
| Min length | 3 |
Characters and Unicode
| Total characters | 8450497 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Sedalia |
|---|---|
| 2nd row | Williston |
| 3rd row | Silver City |
| 4th row | Dunkirk |
| 5th row | Stroudsburg |
| Value | Count | Frequency (%) |
| city | 32161 | 2.6% |
| new | 14047 | 1.2% |
| beach | 13726 | 1.1% |
| san | 12949 | 1.1% |
| springs | 10660 | 0.9% |
| fort | 10024 | 0.8% |
| park | 9132 | 0.8% |
| west | 8548 | 0.7% |
| saint | 7971 | 0.7% |
| falls | 6906 | 0.6% |
| Other values (1634) | 1090751 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 777071 | 9.2% |
| e | 776788 | 9.2% |
| n | 643293 | 7.6% |
| o | 634555 | 7.5% |
| r | 534447 | 6.3% |
| l | 513454 | 6.1% |
| i | 509793 | 6.0% |
| t | 467095 | 5.5% |
| s | 353589 | 4.2% |
| 250475 | 3.0% | |
| Other values (44) | 2989937 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8450497 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 777071 | 9.2% |
| e | 776788 | 9.2% |
| n | 643293 | 7.6% |
| o | 634555 | 7.5% |
| r | 534447 | 6.3% |
| l | 513454 | 6.1% |
| i | 509793 | 6.0% |
| t | 467095 | 5.5% |
| s | 353589 | 4.2% |
| 250475 | 3.0% | |
| Other values (44) | 2989937 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8450497 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 777071 | 9.2% |
| e | 776788 | 9.2% |
| n | 643293 | 7.6% |
| o | 634555 | 7.5% |
| r | 534447 | 6.3% |
| l | 513454 | 6.1% |
| i | 509793 | 6.0% |
| t | 467095 | 5.5% |
| s | 353589 | 4.2% |
| 250475 | 3.0% | |
| Other values (44) | 2989937 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8450497 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 777071 | 9.2% |
| e | 776788 | 9.2% |
| n | 643293 | 7.6% |
| o | 634555 | 7.5% |
| r | 534447 | 6.3% |
| l | 513454 | 6.1% |
| i | 509793 | 6.0% |
| t | 467095 | 5.5% |
| s | 353589 | 4.2% |
| 250475 | 3.0% | |
| Other values (44) | 2989937 |
STATE
Categorical
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.4 MiB |
| California | |
|---|---|
| Illinois | 56753 |
| Massachusetts | 47597 |
| Connecticut | 41359 |
| New York | 39138 |
| Other values (45) |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 8.5429739 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8255930 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Missouri |
|---|---|
| 2nd row | North Dakota |
| 3rd row | New Mexico |
| 4th row | New York |
| 5th row | Pennsylvania |
Common Values
| Value | Count | Frequency (%) |
| California | 111427 | 11.5% |
| Illinois | 56753 | 5.9% |
| Massachusetts | 47597 | 4.9% |
| Connecticut | 41359 | 4.3% |
| New York | 39138 | 4.0% |
| Alabama | 38935 | 4.0% |
| Florida | 38350 | 4.0% |
| Colorado | 30124 | 3.1% |
| New Jersey | 26100 | 2.7% |
| Arkansas | 25677 | 2.7% |
| Other values (40) | 510940 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| california | 111427 | 10.1% |
| new | 84237 | 7.6% |
| illinois | 56753 | 5.1% |
| massachusetts | 47597 | 4.3% |
| connecticut | 41359 | 3.8% |
| york | 39138 | 3.6% |
| alabama | 38935 | 3.5% |
| florida | 38350 | 3.5% |
| colorado | 30124 | 2.7% |
| jersey | 26100 | 2.4% |
| Other values (42) | 588071 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1132803 | |
| i | 865262 | 10.5% |
| n | 692063 | 8.4% |
| o | 663356 | 8.0% |
| s | 604292 | 7.3% |
| e | 451896 | 5.5% |
| r | 443948 | 5.4% |
| l | 435199 | 5.3% |
| t | 293046 | 3.5% |
| C | 205185 | 2.5% |
| Other values (36) | 2468880 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8255930 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1132803 | |
| i | 865262 | 10.5% |
| n | 692063 | 8.4% |
| o | 663356 | 8.0% |
| s | 604292 | 7.3% |
| e | 451896 | 5.5% |
| r | 443948 | 5.4% |
| l | 435199 | 5.3% |
| t | 293046 | 3.5% |
| C | 205185 | 2.5% |
| Other values (36) | 2468880 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8255930 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1132803 | |
| i | 865262 | 10.5% |
| n | 692063 | 8.4% |
| o | 663356 | 8.0% |
| s | 604292 | 7.3% |
| e | 451896 | 5.5% |
| r | 443948 | 5.4% |
| l | 435199 | 5.3% |
| t | 293046 | 3.5% |
| C | 205185 | 2.5% |
| Other values (36) | 2468880 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8255930 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1132803 | |
| i | 865262 | 10.5% |
| n | 692063 | 8.4% |
| o | 663356 | 8.0% |
| s | 604292 | 7.3% |
| e | 451896 | 5.5% |
| r | 443948 | 5.4% |
| l | 435199 | 5.3% |
| t | 293046 | 3.5% |
| C | 205185 | 2.5% |
| Other values (36) | 2468880 |
COUNTY
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.9 MiB |
| City Center | |
|---|---|
| Dolphin | |
| Orange | |
| Santa Cruz | |
| Scott | |
| Other values (4) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.0649369 |
| Min length | 5 |
Characters and Unicode
| Total characters | 8760355 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | City Center |
|---|---|
| 2nd row | City Center |
| 3rd row | Santa Cruz |
| 4th row | Dolphin |
| 5th row | City Center |
Common Values
| Value | Count | Frequency (%) |
| City Center | 507296 | |
| Dolphin | 148154 | 15.3% |
| Orange | 86564 | 9.0% |
| Santa Cruz | 63187 | 6.5% |
| Scott | 50866 | 5.3% |
| Silver | 40951 | 4.2% |
| Spencer | 31985 | 3.3% |
| Stephens | 21727 | 2.2% |
| Sumter | 15670 | 1.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| city | 507296 | |
| center | 507296 | |
| dolphin | 148154 | 9.6% |
| orange | 86564 | 5.6% |
| santa | 63187 | 4.1% |
| cruz | 63187 | 4.1% |
| scott | 50866 | 3.3% |
| silver | 40951 | 2.7% |
| spencer | 31985 | 2.1% |
| stephens | 21727 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1265201 | |
| t | 1216908 | |
| C | 1077779 | |
| n | 858913 | |
| r | 745653 | |
| i | 696401 | |
| 570483 | ||
| y | 507296 | 5.8% |
| S | 224386 | 2.6% |
| a | 212938 | 2.4% |
| Other values (13) | 1384397 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8760355 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1265201 | |
| t | 1216908 | |
| C | 1077779 | |
| n | 858913 | |
| r | 745653 | |
| i | 696401 | |
| 570483 | ||
| y | 507296 | 5.8% |
| S | 224386 | 2.6% |
| a | 212938 | 2.4% |
| Other values (13) | 1384397 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8760355 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1265201 | |
| t | 1216908 | |
| C | 1077779 | |
| n | 858913 | |
| r | 745653 | |
| i | 696401 | |
| 570483 | ||
| y | 507296 | 5.8% |
| S | 224386 | 2.6% |
| a | 212938 | 2.4% |
| Other values (13) | 1384397 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8760355 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1265201 | |
| t | 1216908 | |
| C | 1077779 | |
| n | 858913 | |
| r | 745653 | |
| i | 696401 | |
| 570483 | ||
| y | 507296 | 5.8% |
| S | 224386 | 2.6% |
| a | 212938 | 2.4% |
| Other values (13) | 1384397 |
STREET
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.2 MiB |
| Str1 | |
|---|---|
| Str4 | |
| Str2 | |
| Str5 | |
| Str3 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3865600 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Str4 |
|---|---|
| 2nd row | Str1 |
| 3rd row | Str1 |
| 4th row | Str3 |
| 5th row | Str2 |
Common Values
| Value | Count | Frequency (%) |
| Str1 | 201506 | |
| Str4 | 198939 | |
| Str2 | 194809 | |
| Str5 | 194441 | |
| Str3 | 176705 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| str1 | 201506 | |
| str4 | 198939 | |
| str2 | 194809 | |
| str5 | 194441 | |
| str3 | 176705 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 966400 | |
| t | 966400 | |
| r | 966400 | |
| 1 | 201506 | 5.2% |
| 4 | 198939 | 5.1% |
| 2 | 194809 | 5.0% |
| 5 | 194441 | 5.0% |
| 3 | 176705 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3865600 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 966400 | |
| t | 966400 | |
| r | 966400 | |
| 1 | 201506 | 5.2% |
| 4 | 198939 | 5.1% |
| 2 | 194809 | 5.0% |
| 5 | 194441 | 5.0% |
| 3 | 176705 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3865600 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 966400 | |
| t | 966400 | |
| r | 966400 | |
| 1 | 201506 | 5.2% |
| 4 | 198939 | 5.1% |
| 2 | 194809 | 5.0% |
| 5 | 194441 | 5.0% |
| 3 | 176705 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3865600 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 966400 | |
| t | 966400 | |
| r | 966400 | |
| 1 | 201506 | 5.2% |
| 4 | 198939 | 5.1% |
| 2 | 194809 | 5.0% |
| 5 | 194441 | 5.0% |
| 3 | 176705 | 4.6% |
PRODUCT_CODE
Text
| Distinct | 94 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 59.0 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 6764800 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRD0064 |
|---|---|
| 2nd row | PRD0113 |
| 3rd row | PRD0107 |
| 4th row | PRD0147 |
| 5th row | PRD0004 |
| Value | Count | Frequency (%) |
| prd0106 | 107597 | 11.1% |
| prd0105 | 51482 | 5.3% |
| prd0147 | 43794 | 4.5% |
| prd0069 | 33926 | 3.5% |
| prd0058 | 31868 | 3.3% |
| prd0094 | 30319 | 3.1% |
| prd0015 | 29173 | 3.0% |
| prd0112 | 27877 | 2.9% |
| prd0107 | 26910 | 2.8% |
| prd0096 | 26421 | 2.7% |
| Other values (84) | 557033 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1736312 | |
| P | 966400 | |
| R | 966400 | |
| D | 966400 | |
| 1 | 641564 | 9.5% |
| 6 | 290649 | 4.3% |
| 5 | 230585 | 3.4% |
| 9 | 202083 | 3.0% |
| 2 | 187942 | 2.8% |
| 8 | 156096 | 2.3% |
| Other values (3) | 420369 | 6.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6764800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1736312 | |
| P | 966400 | |
| R | 966400 | |
| D | 966400 | |
| 1 | 641564 | 9.5% |
| 6 | 290649 | 4.3% |
| 5 | 230585 | 3.4% |
| 9 | 202083 | 3.0% |
| 2 | 187942 | 2.8% |
| 8 | 156096 | 2.3% |
| Other values (3) | 420369 | 6.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6764800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1736312 | |
| P | 966400 | |
| R | 966400 | |
| D | 966400 | |
| 1 | 641564 | 9.5% |
| 6 | 290649 | 4.3% |
| 5 | 230585 | 3.4% |
| 9 | 202083 | 3.0% |
| 2 | 187942 | 2.8% |
| 8 | 156096 | 2.3% |
| Other values (3) | 420369 | 6.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6764800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1736312 | |
| P | 966400 | |
| R | 966400 | |
| D | 966400 | |
| 1 | 641564 | 9.5% |
| 6 | 290649 | 4.3% |
| 5 | 230585 | 3.4% |
| 9 | 202083 | 3.0% |
| 2 | 187942 | 2.8% |
| 8 | 156096 | 2.3% |
| Other values (3) | 420369 | 6.2% |
CATEGORY
Categorical
HIGH CORRELATION
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.7 MiB |
| Soap | |
|---|---|
| Perfume and Deodrants | |
| Hair Care | |
| Lotion | |
| Kids Care | |
| Other values (2) |
Length
| Max length | 21 |
|---|---|
| Median length | 9 |
| Mean length | 9.9073489 |
| Min length | 4 |
Characters and Unicode
| Total characters | 9574462 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hair Care |
|---|---|
| 2nd row | Perfume and Deodrants |
| 3rd row | Lotion |
| 4th row | Kids Care |
| 5th row | Lotion |
Common Values
| Value | Count | Frequency (%) |
| Soap | 251031 | |
| Perfume and Deodrants | 224223 | |
| Hair Care | 203882 | |
| Lotion | 138579 | |
| Kids Care | 101069 | |
| Dental | 47542 | 4.9% |
| Wipes | 74 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| care | 304951 | |
| soap | 251031 | |
| perfume | 224223 | |
| and | 224223 | |
| deodrants | 224223 | |
| hair | 203882 | |
| lotion | 138579 | |
| kids | 101069 | 5.9% |
| dental | 47542 | 2.8% |
| wipes | 74 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1255852 | |
| e | 1025236 | |
| r | 957279 | 10.0% |
| 753397 | 7.9% | |
| o | 752412 | 7.9% |
| n | 634567 | 6.6% |
| d | 549515 | 5.7% |
| i | 443604 | 4.6% |
| t | 410344 | 4.3% |
| s | 325366 | 3.4% |
| Other values (13) | 2466890 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9574462 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1255852 | |
| e | 1025236 | |
| r | 957279 | 10.0% |
| 753397 | 7.9% | |
| o | 752412 | 7.9% |
| n | 634567 | 6.6% |
| d | 549515 | 5.7% |
| i | 443604 | 4.6% |
| t | 410344 | 4.3% |
| s | 325366 | 3.4% |
| Other values (13) | 2466890 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9574462 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1255852 | |
| e | 1025236 | |
| r | 957279 | 10.0% |
| 753397 | 7.9% | |
| o | 752412 | 7.9% |
| n | 634567 | 6.6% |
| d | 549515 | 5.7% |
| i | 443604 | 4.6% |
| t | 410344 | 4.3% |
| s | 325366 | 3.4% |
| Other values (13) | 2466890 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9574462 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1255852 | |
| e | 1025236 | |
| r | 957279 | 10.0% |
| 753397 | 7.9% | |
| o | 752412 | 7.9% |
| n | 634567 | 6.6% |
| d | 549515 | 5.7% |
| i | 443604 | 4.6% |
| t | 410344 | 4.3% |
| s | 325366 | 3.4% |
| Other values (13) | 2466890 |
SUBCATEGORY
Categorical
HIGH CORRELATION
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.6 MiB |
| Shampoo | |
|---|---|
| Head Lotion | |
| Soap Gels | |
| Toilet Soap | |
| Female Perfume | |
| Other values (20) |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 10.878238 |
| Min length | 3 |
Characters and Unicode
| Total characters | 10512729 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Conditioner |
|---|---|
| 2nd row | Unisex Deodrant |
| 3rd row | Body Lotion |
| 4th row | Baby Cream |
| 5th row | Body Lotion |
Common Values
| Value | Count | Frequency (%) |
| Shampoo | 123413 | |
| Head Lotion | 82722 | 8.6% |
| Soap Gels | 68794 | 7.1% |
| Toilet Soap | 68763 | 7.1% |
| Female Perfume | 60317 | 6.2% |
| Female Deodrant | 58640 | 6.1% |
| Body Lotion | 55857 | 5.8% |
| Liquid Soap | 50112 | 5.2% |
| Hair Oil | 48057 | 5.0% |
| Medicated Soap | 46940 | 4.9% |
| Other values (15) | 302785 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| soap | 251031 | |
| shampoo | 151515 | 8.9% |
| lotion | 138579 | 8.2% |
| perfume | 125338 | 7.4% |
| female | 118957 | 7.0% |
| deodrant | 98885 | 5.8% |
| head | 82722 | 4.9% |
| baby | 71896 | 4.2% |
| gels | 68794 | 4.0% |
| toilet | 68763 | 4.0% |
| Other values (17) | 523706 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1214507 | 11.6% |
| e | 1169659 | 11.1% |
| a | 1037431 | 9.9% |
| 733786 | 7.0% | |
| i | 612885 | 5.8% |
| t | 490496 | 4.7% |
| m | 439604 | 4.2% |
| p | 431719 | 4.1% |
| d | 413868 | 3.9% |
| S | 402546 | 3.8% |
| Other values (26) | 3566228 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10512729 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 1214507 | 11.6% |
| e | 1169659 | 11.1% |
| a | 1037431 | 9.9% |
| 733786 | 7.0% | |
| i | 612885 | 5.8% |
| t | 490496 | 4.7% |
| m | 439604 | 4.2% |
| p | 431719 | 4.1% |
| d | 413868 | 3.9% |
| S | 402546 | 3.8% |
| Other values (26) | 3566228 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10512729 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 1214507 | 11.6% |
| e | 1169659 | 11.1% |
| a | 1037431 | 9.9% |
| 733786 | 7.0% | |
| i | 612885 | 5.8% |
| t | 490496 | 4.7% |
| m | 439604 | 4.2% |
| p | 431719 | 4.1% |
| d | 413868 | 3.9% |
| S | 402546 | 3.8% |
| Other values (26) | 3566228 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10512729 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 1214507 | 11.6% |
| e | 1169659 | 11.1% |
| a | 1037431 | 9.9% |
| 733786 | 7.0% | |
| i | 612885 | 5.8% |
| t | 490496 | 4.7% |
| m | 439604 | 4.2% |
| p | 431719 | 4.1% |
| d | 413868 | 3.9% |
| S | 402546 | 3.8% |
| Other values (26) | 3566228 |
BRAND
Text
| Distinct | 89 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.0 MiB |
Length
| Max length | 26 |
|---|---|
| Median length | 17 |
| Mean length | 8.1101076 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7837608 |
|---|---|
| Distinct characters | 49 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bamboo |
|---|---|
| 2nd row | Navy Blue |
| 3rd row | Coral |
| 4th row | Mint |
| 5th row | Tan |
| Value | Count | Frequency (%) |
| shoulders | 107597 | 7.6% |
| hair | 107597 | 7.6% |
| 107597 | 7.6% | |
| green | 55054 | 3.9% |
| garnet | 51482 | 3.7% |
| toothy | 47412 | 3.4% |
| mint | 43794 | 3.1% |
| blue | 42376 | 3.0% |
| fuchsia | 34059 | 2.4% |
| arctic | 33926 | 2.4% |
| Other values (91) | 778481 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 731404 | 9.3% |
| r | 642306 | 8.2% |
| a | 598243 | 7.6% |
| i | 477346 | 6.1% |
| o | 470321 | 6.0% |
| 442975 | 5.7% | |
| l | 394044 | 5.0% |
| n | 391404 | 5.0% |
| u | 378063 | 4.8% |
| s | 327239 | 4.2% |
| Other values (39) | 2984263 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7837608 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 731404 | 9.3% |
| r | 642306 | 8.2% |
| a | 598243 | 7.6% |
| i | 477346 | 6.1% |
| o | 470321 | 6.0% |
| 442975 | 5.7% | |
| l | 394044 | 5.0% |
| n | 391404 | 5.0% |
| u | 378063 | 4.8% |
| s | 327239 | 4.2% |
| Other values (39) | 2984263 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7837608 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 731404 | 9.3% |
| r | 642306 | 8.2% |
| a | 598243 | 7.6% |
| i | 477346 | 6.1% |
| o | 470321 | 6.0% |
| 442975 | 5.7% | |
| l | 394044 | 5.0% |
| n | 391404 | 5.0% |
| u | 378063 | 4.8% |
| s | 327239 | 4.2% |
| Other values (39) | 2984263 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7837608 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 731404 | 9.3% |
| r | 642306 | 8.2% |
| a | 598243 | 7.6% |
| i | 477346 | 6.1% |
| o | 470321 | 6.0% |
| 442975 | 5.7% | |
| l | 394044 | 5.0% |
| n | 391404 | 5.0% |
| u | 378063 | 4.8% |
| s | 327239 | 4.2% |
| Other values (39) | 2984263 |
YEAR
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.2 MiB |
| 2024 | |
|---|---|
| 2023 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3865600 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024 |
|---|---|
| 2nd row | 2024 |
| 3rd row | 2024 |
| 4th row | 2024 |
| 5th row | 2024 |
Common Values
| Value | Count | Frequency (%) |
| 2024 | 640754 | |
| 2023 | 325646 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024 | 640754 | |
| 2023 | 325646 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1932800 | |
| 0 | 966400 | |
| 4 | 640754 | 16.6% |
| 3 | 325646 | 8.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3865600 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1932800 | |
| 0 | 966400 | |
| 4 | 640754 | 16.6% |
| 3 | 325646 | 8.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3865600 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1932800 | |
| 0 | 966400 | |
| 4 | 640754 | 16.6% |
| 3 | 325646 | 8.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3865600 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1932800 | |
| 0 | 966400 | |
| 4 | 640754 | 16.6% |
| 3 | 325646 | 8.4% |
MONTH
Real number (ℝ)
HIGH CORRELATION
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5577276 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.3992721 |
|---|---|
| Coefficient of variation (CV) | 0.51836128 |
| Kurtosis | -1.1615238 |
| Mean | 6.5577276 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.017029888 |
| Sum | 6337388 |
| Variance | 11.555051 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 6 | 90323 | |
| 7 | 89142 | |
| 9 | 84176 | |
| 12 | 81803 | |
| 8 | 80941 | |
| 5 | 79524 | |
| 3 | 78949 | |
| 11 | 78312 | |
| 4 | 77778 | |
| 1 | 76199 | |
| Other values (2) | 149253 |
| Value | Count | Frequency (%) |
| 1 | 76199 | |
| 2 | 73879 | |
| 3 | 78949 | |
| 4 | 77778 | |
| 5 | 79524 | |
| 6 | 90323 | |
| 7 | 89142 | |
| 8 | 80941 | |
| 9 | 84176 | |
| 10 | 75374 |
| Value | Count | Frequency (%) |
| 12 | 81803 | |
| 11 | 78312 | |
| 10 | 75374 | |
| 9 | 84176 | |
| 8 | 80941 | |
| 7 | 89142 | |
| 6 | 90323 | |
| 5 | 79524 | |
| 4 | 77778 | |
| 3 | 78949 |
DAY
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.405579 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 15 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.6320286 |
|---|---|
| Coefficient of variation (CV) | 0.56031833 |
| Kurtosis | -1.1645462 |
| Mean | 15.405579 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.060867129 |
| Sum | 14887952 |
| Variance | 74.511917 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 7 | 40600 | 4.2% |
| 8 | 39399 | 4.1% |
| 22 | 37408 | 3.9% |
| 19 | 36714 | 3.8% |
| 12 | 35493 | 3.7% |
| 21 | 34942 | 3.6% |
| 9 | 34474 | 3.6% |
| 14 | 33884 | 3.5% |
| 11 | 33076 | 3.4% |
| 10 | 33070 | 3.4% |
| Other values (21) | 607340 |
| Value | Count | Frequency (%) |
| 1 | 31124 | |
| 2 | 30420 | |
| 3 | 29215 | |
| 4 | 29139 | |
| 5 | 31719 | |
| 6 | 32819 | |
| 7 | 40600 | |
| 8 | 39399 | |
| 9 | 34474 | |
| 10 | 33070 |
| Value | Count | Frequency (%) |
| 31 | 15524 | |
| 30 | 25737 | |
| 29 | 27864 | |
| 28 | 31243 | |
| 27 | 26785 | |
| 26 | 27850 | |
| 25 | 27850 | |
| 24 | 30177 | |
| 23 | 30214 | |
| 22 | 37408 |
DAY_OF_WEEK
Real number (ℝ)
ZEROS
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3241401 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 102473 |
| Zeros (%) | 10.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.9529069 |
|---|---|
| Coefficient of variation (CV) | 0.58749236 |
| Kurtosis | -1.1390929 |
| Mean | 3.3241401 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.24292582 |
| Sum | 3212449 |
| Variance | 3.8138455 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 4 | 166790 | |
| 3 | 160887 | |
| 5 | 160520 | |
| 6 | 160304 | |
| 1 | 132648 | |
| 0 | 102473 | |
| 2 | 82778 |
| Value | Count | Frequency (%) |
| 0 | 102473 | |
| 1 | 132648 | |
| 2 | 82778 | |
| 3 | 160887 | |
| 4 | 166790 | |
| 5 | 160520 | |
| 6 | 160304 |
| Value | Count | Frequency (%) |
| 6 | 160304 | |
| 5 | 160520 | |
| 4 | 166790 | |
| 3 | 160887 | |
| 2 | 82778 | |
| 1 | 132648 | |
| 0 | 102473 |
QUARTER
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.5 MiB |
| 3 | |
|---|---|
| 2 | |
| 4 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 966400 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 254259 | |
| 2 | 247625 | |
| 4 | 235489 | |
| 1 | 229027 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 254259 | |
| 2 | 247625 | |
| 4 | 235489 | |
| 1 | 229027 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 254259 | |
| 2 | 247625 | |
| 4 | 235489 | |
| 1 | 229027 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 966400 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 254259 | |
| 2 | 247625 | |
| 4 | 235489 | |
| 1 | 229027 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 966400 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 254259 | |
| 2 | 247625 | |
| 4 | 235489 | |
| 1 | 229027 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 966400 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 254259 | |
| 2 | 247625 | |
| 4 | 235489 | |
| 1 | 229027 |
DAY_OF_YEAR
Real number (ℝ)
HIGH CORRELATION
| Distinct | 303 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 184.15113 |
| Minimum | 3 |
|---|---|
| Maximum | 365 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 19 |
| Q1 | 97 |
| median | 186 |
| Q3 | 271 |
| 95-th percentile | 347 |
| Maximum | 365 |
| Range | 362 |
| Interquartile range (IQR) | 174 |
Descriptive statistics
| Standard deviation | 103.70325 |
|---|---|
| Coefficient of variation (CV) | 0.56314208 |
| Kurtosis | -1.1452495 |
| Mean | 184.15113 |
| Median Absolute Deviation (MAD) | 87 |
| Skewness | -0.016206668 |
| Sum | 1.7796366 × 108 |
| Variance | 10754.364 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 274 | 6296 | 0.7% |
| 285 | 5185 | 0.5% |
| 284 | 5073 | 0.5% |
| 250 | 5048 | 0.5% |
| 100 | 4503 | 0.5% |
| 187 | 4483 | 0.5% |
| 235 | 4456 | 0.5% |
| 188 | 4421 | 0.5% |
| 311 | 4316 | 0.4% |
| 33 | 4313 | 0.4% |
| Other values (293) | 918306 |
| Value | Count | Frequency (%) |
| 3 | 3400 | |
| 4 | 3942 | |
| 5 | 3787 | |
| 6 | 3263 | |
| 7 | 3531 | |
| 8 | 3936 | |
| 10 | 3209 | |
| 11 | 3381 | |
| 12 | 3246 | |
| 13 | 3049 |
| Value | Count | Frequency (%) |
| 365 | 2959 | |
| 364 | 2057 | |
| 363 | 2416 | |
| 362 | 2397 | |
| 361 | 2886 | |
| 360 | 2824 | |
| 358 | 2929 | |
| 357 | 2795 | |
| 356 | 2973 | |
| 355 | 3259 |
| CATEGORY | COUNTY | DAY | DAY_OF_WEEK | DAY_OF_YEAR | DISTRIBUTOR_CODE | MNTH_CODE | MONTH | OC_CODE | QUARTER | SALES_PTR_VALUE | SALES_UNITS | SALES_VALUE | SALES_VOLUME | STATE | STREET | SUBCATEGORY | YEAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CATEGORY | 1.000 | 0.091 | 0.011 | 0.007 | 0.032 | 0.024 | 0.026 | 0.037 | 0.039 | 0.025 | 0.008 | 0.006 | 0.008 | 0.005 | 0.040 | 0.008 | 1.000 | 0.026 |
| COUNTY | 0.091 | 1.000 | 0.015 | 0.023 | 0.030 | 0.089 | 0.038 | 0.030 | 0.030 | 0.039 | 0.008 | 0.005 | 0.008 | 0.008 | 0.080 | 0.061 | 0.194 | 0.038 |
| DAY | 0.011 | 0.015 | 1.000 | -0.040 | 0.092 | 0.014 | -0.030 | 0.009 | 0.031 | 0.047 | 0.003 | 0.006 | 0.005 | 0.002 | 0.019 | 0.007 | 0.016 | 0.071 |
| DAY_OF_WEEK | 0.007 | 0.023 | -0.040 | 1.000 | 0.040 | 0.014 | -0.057 | 0.043 | 0.039 | 0.180 | -0.023 | 0.010 | -0.023 | -0.020 | 0.052 | 0.020 | 0.017 | 0.312 |
| DAY_OF_YEAR | 0.032 | 0.030 | 0.092 | 0.040 | 1.000 | 0.014 | -0.349 | 0.996 | 0.996 | 0.925 | 0.006 | 0.046 | -0.006 | -0.016 | 0.012 | 0.007 | 0.054 | 0.945 |
| DISTRIBUTOR_CODE | 0.024 | 0.089 | 0.014 | 0.014 | 0.014 | 1.000 | 0.011 | 0.014 | 0.014 | 0.012 | 0.008 | 0.005 | 0.008 | 0.007 | 0.089 | 0.033 | 0.071 | 0.011 |
| MNTH_CODE | 0.026 | 0.038 | -0.030 | -0.057 | -0.349 | 0.011 | 1.000 | -0.349 | -0.350 | 0.855 | -0.010 | -0.020 | -0.008 | 0.007 | 0.018 | 0.009 | 0.079 | 1.000 |
| MONTH | 0.037 | 0.030 | 0.009 | 0.043 | 0.996 | 0.014 | -0.349 | 1.000 | 0.998 | 1.000 | 0.006 | 0.046 | -0.007 | -0.017 | 0.013 | 0.007 | 0.061 | 0.987 |
| OC_CODE | 0.039 | 0.030 | 0.031 | 0.039 | 0.996 | 0.014 | -0.350 | 0.998 | 1.000 | 0.981 | 0.006 | 0.046 | -0.007 | -0.017 | 0.013 | 0.007 | 0.064 | 1.000 |
| QUARTER | 0.025 | 0.039 | 0.047 | 0.180 | 0.925 | 0.012 | 0.855 | 1.000 | 0.981 | 1.000 | 0.001 | 0.001 | 0.000 | 0.001 | 0.016 | 0.007 | 0.067 | 0.855 |
| SALES_PTR_VALUE | 0.008 | 0.008 | 0.003 | -0.023 | 0.006 | 0.008 | -0.010 | 0.006 | 0.006 | 0.001 | 1.000 | -0.126 | 0.990 | 0.894 | 0.027 | 0.005 | 0.012 | 0.003 |
| SALES_UNITS | 0.006 | 0.005 | 0.006 | 0.010 | 0.046 | 0.005 | -0.020 | 0.046 | 0.046 | 0.001 | -0.126 | 1.000 | -0.132 | 0.067 | 0.005 | 0.005 | 0.012 | 0.000 |
| SALES_VALUE | 0.008 | 0.008 | 0.005 | -0.023 | -0.006 | 0.008 | -0.008 | -0.007 | -0.007 | 0.000 | 0.990 | -0.132 | 1.000 | 0.885 | 0.025 | 0.005 | 0.011 | 0.002 |
| SALES_VOLUME | 0.005 | 0.008 | 0.002 | -0.020 | -0.016 | 0.007 | 0.007 | -0.017 | -0.017 | 0.001 | 0.894 | 0.067 | 0.885 | 1.000 | 0.018 | 0.004 | 0.010 | 0.005 |
| STATE | 0.040 | 0.080 | 0.019 | 0.052 | 0.012 | 0.089 | 0.018 | 0.013 | 0.013 | 0.016 | 0.027 | 0.005 | 0.025 | 0.018 | 1.000 | 0.098 | 0.048 | 0.018 |
| STREET | 0.008 | 0.061 | 0.007 | 0.020 | 0.007 | 0.033 | 0.009 | 0.007 | 0.007 | 0.007 | 0.005 | 0.005 | 0.005 | 0.004 | 0.098 | 1.000 | 0.019 | 0.009 |
| SUBCATEGORY | 1.000 | 0.194 | 0.016 | 0.017 | 0.054 | 0.071 | 0.079 | 0.061 | 0.064 | 0.067 | 0.012 | 0.012 | 0.011 | 0.010 | 0.048 | 0.019 | 1.000 | 0.079 |
| YEAR | 0.026 | 0.038 | 0.071 | 0.312 | 0.945 | 0.011 | 1.000 | 0.987 | 1.000 | 0.855 | 0.003 | 0.000 | 0.002 | 0.005 | 0.018 | 0.009 | 0.079 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| MNTH_CODE | TRANS_DATE | START_DATE | SALES_VALUE | SALES_UNITS | SALES_VOLUME | SALES_PTR_VALUE | OC_CODE | DISTRIBUTOR_CODE | OUTLET_CODE | CITY | STATE | COUNTY | STREET | PRODUCT_CODE | CATEGORY | SUBCATEGORY | BRAND | YEAR | MONTH | DAY | DAY_OF_WEEK | QUARTER | DAY_OF_YEAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 202401 | 2024-01-18 | 2024-01-02 | 1537.89 | 16 | 0.001712 | 1585.454545 | 202201 | DB0706 | OL144111 | Sedalia | Missouri | City Center | Str4 | PRD0064 | Hair Care | Conditioner | Bamboo | 2024 | 1 | 18 | 3 | 1 | 18 |
| 1 | 202401 | 2024-01-28 | 2024-01-02 | 518.18 | 3 | 0.001125 | 518.181818 | 202201 | DB0706 | OL238706 | Williston | North Dakota | City Center | Str1 | PRD0113 | Perfume and Deodrants | Unisex Deodrant | Navy Blue | 2024 | 1 | 28 | 6 | 1 | 28 |
| 2 | 202401 | 2024-01-13 | 2024-01-02 | 113.64 | 1 | 0.000250 | 113.636364 | 202201 | DB0706 | OL223076 | Silver City | New Mexico | Santa Cruz | Str1 | PRD0107 | Lotion | Body Lotion | Coral | 2024 | 1 | 13 | 5 | 1 | 13 |
| 3 | 202401 | 2024-01-06 | 2024-01-02 | 285.71 | 32 | 0.000832 | 285.714286 | 202201 | DB0652 | OL175529 | Dunkirk | New York | Dolphin | Str3 | PRD0147 | Kids Care | Baby Cream | Mint | 2024 | 1 | 6 | 5 | 1 | 6 |
| 4 | 202401 | 2024-01-18 | 2024-01-02 | 290.91 | 1 | 0.000500 | 290.909091 | 202201 | DB0652 | OL48851 | Stroudsburg | Pennsylvania | City Center | Str2 | PRD0004 | Lotion | Body Lotion | Tan | 2024 | 1 | 18 | 3 | 1 | 18 |
| 5 | 202401 | 2024-01-18 | 2024-01-02 | 873.00 | 3 | 0.001350 | 900.000000 | 202201 | DB0706 | OL159390 | Needles | California | City Center | Str1 | PRD0033 | Soap | Toilet Soap | Turquoise | 2024 | 1 | 18 | 3 | 1 | 18 |
| 6 | 202401 | 2024-01-28 | 2024-01-02 | 54.55 | 1 | 0.000110 | 54.545455 | 202201 | DB0706 | OL239150 | Merced | California | Orange | Str1 | PRD0015 | Kids Care | Diapers | Pearl | 2024 | 1 | 28 | 6 | 1 | 28 |
| 7 | 202401 | 2024-01-04 | 2024-01-02 | 818.18 | 5 | 0.001925 | 818.181818 | 202201 | DB0706 | OL237928 | Harlan | Kentucky | City Center | Str5 | PRD0016 | Hair Care | Hair Oil | Magenta | 2024 | 1 | 4 | 3 | 1 | 4 |
| 8 | 202401 | 2024-01-05 | 2024-01-02 | 142.86 | 16 | 0.000416 | 142.857143 | 202201 | DB0652 | OL48900 | Amherst | Massachusetts | Orange | Str5 | PRD0147 | Kids Care | Baby Cream | Mint | 2024 | 1 | 5 | 4 | 1 | 5 |
| 9 | 202401 | 2024-01-27 | 2024-01-02 | 53.57 | 12 | 0.000144 | 53.571429 | 202201 | DB0110 | OL32584 | Kewanee | Illinois | Silver | Str2 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2024 | 1 | 27 | 5 | 1 | 27 |
| MNTH_CODE | TRANS_DATE | START_DATE | SALES_VALUE | SALES_UNITS | SALES_VOLUME | SALES_PTR_VALUE | OC_CODE | DISTRIBUTOR_CODE | OUTLET_CODE | CITY | STATE | COUNTY | STREET | PRODUCT_CODE | CATEGORY | SUBCATEGORY | BRAND | YEAR | MONTH | DAY | DAY_OF_WEEK | QUARTER | DAY_OF_YEAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 966390 | 202310 | 2023-10-25 | 2023-10-02 | 285.71 | 32 | 0.000832 | 285.714286 | 202210 | DB0110 | OL33455 | Columbia | Pennsylvania | Santa Cruz | Str5 | PRD0069 | Perfume and Deodrants | Female Deodrant | Arctic blue | 2023 | 10 | 25 | 2 | 4 | 298 |
| 966391 | 202310 | 2023-10-24 | 2023-10-02 | 1236.36 | 4 | 0.003600 | 1236.363636 | 202210 | DB0652 | OL96549 | Apalachicola | Florida | City Center | Str3 | PRD0100 | Perfume and Deodrants | Unisex Deodrant | Ash | 2023 | 10 | 24 | 1 | 4 | 297 |
| 966392 | 202310 | 2023-10-24 | 2023-10-02 | 1236.36 | 4 | 0.002860 | 1236.363636 | 202210 | DB0706 | OL207820 | Amsterdam | New York | City Center | Str2 | PRD0017 | Perfume and Deodrants | Male Perfume | Tangerine | 2023 | 10 | 24 | 1 | 4 | 297 |
| 966393 | 202310 | 2023-10-29 | 2023-10-02 | 2127.27 | 12 | 0.003000 | 2127.272727 | 202210 | DB0706 | OL159390 | Needles | California | City Center | Str1 | PRD0122 | Perfume and Deodrants | Female Deodrant | Lilac | 2023 | 10 | 29 | 6 | 4 | 302 |
| 966394 | 202310 | 2023-10-25 | 2023-10-02 | 676.36 | 12 | 0.001320 | 676.363636 | 202210 | DB0110 | OL12445 | South San Francisco | California | City Center | Str5 | PRD0015 | Kids Care | Diapers | Pearl | 2023 | 10 | 25 | 2 | 4 | 298 |
| 966395 | 202310 | 2023-10-29 | 2023-10-02 | 214.29 | 12 | 0.000624 | 214.285714 | 202210 | DB0655 | OL65099 | Jonesborough | Tennessee | Silver | Str2 | PRD0014 | Dental | ToothPaste | Toothy Sensitive | 2023 | 10 | 29 | 6 | 4 | 302 |
| 966396 | 202310 | 2023-10-28 | 2023-10-02 | 1527.27 | 12 | 0.003000 | 1527.272727 | 202210 | DB0655 | OL97239 | Longview | Washington | City Center | Str5 | PRD0107 | Lotion | Body Lotion | Coral | 2023 | 10 | 28 | 5 | 4 | 301 |
| 966397 | 202310 | 2023-10-28 | 2023-10-02 | 285.71 | 36 | 0.000864 | 289.285714 | 202210 | DB0209 | OL160211 | Priest River | Idaho | Santa Cruz | Str4 | PRD0147 | Kids Care | Baby Cream | Mint | 2023 | 10 | 28 | 5 | 4 | 301 |
| 966398 | 202310 | 2023-10-27 | 2023-10-02 | 209.09 | 2 | 0.000214 | 209.090909 | 202210 | DB0655 | OL113187 | Napa | California | Scott | Str1 | PRD0064 | Hair Care | Conditioner | Bamboo | 2023 | 10 | 27 | 4 | 4 | 300 |
| 966399 | 202310 | 2023-10-29 | 2023-10-02 | 285.71 | 32 | 0.000832 | 285.714286 | 202210 | DB0655 | OL238263 | Hazleton | Pennsylvania | Dolphin | Str3 | PRD0069 | Perfume and Deodrants | Female Deodrant | Arctic blue | 2023 | 10 | 29 | 6 | 4 | 302 |
Most frequently occurring
| MNTH_CODE | TRANS_DATE | START_DATE | SALES_VALUE | SALES_UNITS | SALES_VOLUME | SALES_PTR_VALUE | OC_CODE | DISTRIBUTOR_CODE | OUTLET_CODE | CITY | STATE | COUNTY | STREET | PRODUCT_CODE | CATEGORY | SUBCATEGORY | BRAND | YEAR | MONTH | DAY | DAY_OF_WEEK | QUARTER | DAY_OF_YEAR | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 202309 | 2023-10-01 | 2023-08-28 | 8.93 | 1 | 0.000017 | 8.928571 | 202209 | DB0209 | OL65494 | Shelbyville | Tennessee | Santa Cruz | Str5 | PRD0028 | Soap | Toilet Soap | Indigo | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 1 | 202309 | 2023-10-01 | 2023-08-28 | 8.93 | 2 | 0.000022 | 8.928571 | 202209 | DB0110 | OL112602 | Junction City | Kansas | Silver | Str2 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 2 | 202309 | 2023-10-01 | 2023-08-28 | 8.93 | 2 | 0.000022 | 8.928571 | 202209 | DB0110 | OL238594 | Dallas | Texas | Spencer | Str3 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 3 | 202309 | 2023-10-01 | 2023-08-28 | 8.93 | 2 | 0.000022 | 8.928571 | 202209 | DB0110 | OL81664 | Hattiesburg | Mississippi | Orange | Str3 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 4 | 202309 | 2023-10-01 | 2023-08-28 | 13.39 | 3 | 0.000033 | 13.392857 | 202209 | DB0110 | OL144800 | Excelsior Springs | Missouri | Orange | Str4 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 5 | 202309 | 2023-10-01 | 2023-08-28 | 13.39 | 3 | 0.000033 | 13.392857 | 202209 | DB0110 | OL222617 | Indiana | Pennsylvania | Dolphin | Str4 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 6 | 202309 | 2023-10-01 | 2023-08-28 | 13.39 | 3 | 0.000033 | 13.392857 | 202209 | DB0110 | OL33285 | Fall River | Massachusetts | City Center | Str3 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 7 | 202309 | 2023-10-01 | 2023-08-28 | 13.39 | 3 | 0.000033 | 13.392857 | 202209 | DB0110 | OL49488 | Alliance | Ohio | Dolphin | Str3 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 8 | 202309 | 2023-10-01 | 2023-08-28 | 17.86 | 2 | 0.000046 | 17.857143 | 202209 | DB0652 | OL96577 | West Covina | California | City Center | Str1 | PRD0027 | Dental | ToothPaste | Toothy Fresh | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |
| 9 | 202309 | 2023-10-01 | 2023-08-28 | 17.86 | 4 | 0.000044 | 17.857143 | 202209 | DB0110 | OL80741 | Glenview | Illinois | Scott | Str2 | PRD0105 | Perfume and Deodrants | Female Perfume | Garnet | 2023 | 10 | 1 | 6 | 4 | 274 | 2 |